<!DOCTYPE html>
<html>
<head><title>R: A Grammar of Data Manipulation</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=yes" />
<link rel="stylesheet" type="text/css" href="R.css" />
</head><body><div class="container">
<h1> A Grammar of Data Manipulation
<img class="toplogo" src="../../../doc/html/Rlogo.svg" alt="[R logo]" />
</h1>
<hr/>
<div style="text-align: center;">
<a href="../../../doc/html/packages.html"><img class="arrow" src="../../../doc/html/left.jpg" alt="[Up]" /></a>
<a href="../../../doc/html/index.html"><img class="arrow" src="../../../doc/html/up.jpg" alt="[Top]" /></a>
</div><h2>Documentation for package &lsquo;dplyr&rsquo; version 1.1.2</h2>

<ul><li><a href="../DESCRIPTION">DESCRIPTION file</a>.</li>
<li><a href="../doc/index.html">User guides, package vignettes and other documentation.</a></li>
<li><a href="../NEWS">Package NEWS</a>.</li>
</ul>

<h2>Help Pages</h2>


<p style="text-align: center;">
<a href="#A">A</a>
<a href="#B">B</a>
<a href="#C">C</a>
<a href="#D">D</a>
<a href="#E">E</a>
<a href="#F">F</a>
<a href="#G">G</a>
<a href="#I">I</a>
<a href="#J">J</a>
<a href="#L">L</a>
<a href="#M">M</a>
<a href="#N">N</a>
<a href="#O">O</a>
<a href="#P">P</a>
<a href="#R">R</a>
<a href="#S">S</a>
<a href="#T">T</a>
<a href="#U">U</a>
<a href="#V">V</a>
<a href="#W">W</a>
</p>


<h2><a id="A">-- A --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="across.html">across</a></td>
<td>Apply a function (or functions) across multiple columns</td></tr>
<tr><td style="width: 25%;"><a href="count.html">add_count</a></td>
<td>Count the observations in each group</td></tr>
<tr><td style="width: 25%;"><a href="count.html">add_tally</a></td>
<td>Count the observations in each group</td></tr>
<tr><td style="width: 25%;"><a href="all_vars.html">all_vars</a></td>
<td>Apply predicate to all variables</td></tr>
<tr><td style="width: 25%;"><a href="filter-joins.html">anti_join</a></td>
<td>Filtering joins</td></tr>
<tr><td style="width: 25%;"><a href="filter-joins.html">anti_join.data.frame</a></td>
<td>Filtering joins</td></tr>
<tr><td style="width: 25%;"><a href="all_vars.html">any_vars</a></td>
<td>Apply predicate to all variables</td></tr>
<tr><td style="width: 25%;"><a href="arrange.html">arrange</a></td>
<td>Order rows using column values</td></tr>
<tr><td style="width: 25%;"><a href="arrange.html">arrange.data.frame</a></td>
<td>Order rows using column values</td></tr>
<tr><td style="width: 25%;"><a href="auto_copy.html">auto_copy</a></td>
<td>Copy tables to same source, if necessary</td></tr>
</table>

<h2><a id="B">-- B --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="band_members.html">band_instruments</a></td>
<td>Band membership</td></tr>
<tr><td style="width: 25%;"><a href="band_members.html">band_instruments2</a></td>
<td>Band membership</td></tr>
<tr><td style="width: 25%;"><a href="band_members.html">band_members</a></td>
<td>Band membership</td></tr>
<tr><td style="width: 25%;"><a href="between.html">between</a></td>
<td>Detect where values fall in a specified range</td></tr>
<tr><td style="width: 25%;"><a href="bind_rows.html">bind</a></td>
<td>Bind multiple data frames by row</td></tr>
<tr><td style="width: 25%;"><a href="bind_cols.html">bind_cols</a></td>
<td>Bind multiple data frames by column</td></tr>
<tr><td style="width: 25%;"><a href="bind_rows.html">bind_rows</a></td>
<td>Bind multiple data frames by row</td></tr>
</table>

<h2><a id="C">-- C --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="case_match.html">case_match</a></td>
<td>A general vectorised 'switch()'</td></tr>
<tr><td style="width: 25%;"><a href="case_when.html">case_when</a></td>
<td>A general vectorised if-else</td></tr>
<tr><td style="width: 25%;"><a href="join_by.html">closest</a></td>
<td>Join specifications</td></tr>
<tr><td style="width: 25%;"><a href="coalesce.html">coalesce</a></td>
<td>Find the first non-missing element</td></tr>
<tr><td style="width: 25%;"><a href="compute.html">collapse</a></td>
<td>Force computation of a database query</td></tr>
<tr><td style="width: 25%;"><a href="compute.html">collect</a></td>
<td>Force computation of a database query</td></tr>
<tr><td style="width: 25%;"><a href="compute.html">compute</a></td>
<td>Force computation of a database query</td></tr>
<tr><td style="width: 25%;"><a href="consecutive_id.html">consecutive_id</a></td>
<td>Generate a unique identifier for consecutive combinations</td></tr>
<tr><td style="width: 25%;"><a href="context.html">context</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="copy_to.html">copy_to</a></td>
<td>Copy a local data frame to a remote src</td></tr>
<tr><td style="width: 25%;"><a href="count.html">count</a></td>
<td>Count the observations in each group</td></tr>
<tr><td style="width: 25%;"><a href="count.html">count.data.frame</a></td>
<td>Count the observations in each group</td></tr>
<tr><td style="width: 25%;"><a href="cross_join.html">cross_join</a></td>
<td>Cross join</td></tr>
<tr><td style="width: 25%;"><a href="cumall.html">cumall</a></td>
<td>Cumulativate versions of any, all, and mean</td></tr>
<tr><td style="width: 25%;"><a href="cumall.html">cumany</a></td>
<td>Cumulativate versions of any, all, and mean</td></tr>
<tr><td style="width: 25%;"><a href="percent_rank.html">cume_dist</a></td>
<td>Proportional ranking functions</td></tr>
<tr><td style="width: 25%;"><a href="cumall.html">cummean</a></td>
<td>Cumulativate versions of any, all, and mean</td></tr>
<tr><td style="width: 25%;"><a href="context.html">cur_column</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="context.html">cur_group</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="context.html">cur_group_id</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="context.html">cur_group_rows</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="c_across.html">c_across</a></td>
<td>Combine values from multiple columns</td></tr>
</table>

<h2><a id="D">-- D --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="row_number.html">dense_rank</a></td>
<td>Integer ranking functions</td></tr>
<tr><td style="width: 25%;"><a href="desc.html">desc</a></td>
<td>Descending order</td></tr>
<tr><td style="width: 25%;"><a href="distinct.html">distinct</a></td>
<td>Keep distinct/unique rows</td></tr>
<tr><td style="width: 25%;"><a href="dplyr_by.html">dplyr_by</a></td>
<td>Per-operation grouping with '.by'/'by'</td></tr>
</table>

<h2><a id="E">-- E --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="explain.html">explain</a></td>
<td>Explain details of a tbl</td></tr>
</table>

<h2><a id="F">-- F --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="filter.html">filter</a></td>
<td>Keep rows that match a condition</td></tr>
<tr><td style="width: 25%;"><a href="filter-joins.html">filter-joins</a></td>
<td>Filtering joins</td></tr>
<tr><td style="width: 25%;"><a href="nth.html">first</a></td>
<td>Extract the first, last, or nth value from a vector</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">full_join</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">full_join.data.frame</a></td>
<td>Mutating joins</td></tr>
</table>

<h2><a id="G">-- G --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="glimpse.html">glimpse</a></td>
<td>Get a glimpse of your data</td></tr>
<tr><td style="width: 25%;"><a href="group_by.html">group_by</a></td>
<td>Group by one or more variables</td></tr>
<tr><td style="width: 25%;"><a href="group_cols.html">group_cols</a></td>
<td>Select grouping variables</td></tr>
<tr><td style="width: 25%;"><a href="group_map.html">group_map</a></td>
<td>Apply a function to each group</td></tr>
<tr><td style="width: 25%;"><a href="group_map.html">group_modify</a></td>
<td>Apply a function to each group</td></tr>
<tr><td style="width: 25%;"><a href="group_trim.html">group_trim</a></td>
<td>Trim grouping structure</td></tr>
<tr><td style="width: 25%;"><a href="group_map.html">group_walk</a></td>
<td>Apply a function to each group</td></tr>
</table>

<h2><a id="I">-- I --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="ident.html">ident</a></td>
<td>Flag a character vector as SQL identifiers</td></tr>
<tr><td style="width: 25%;"><a href="across.html">if_all</a></td>
<td>Apply a function (or functions) across multiple columns</td></tr>
<tr><td style="width: 25%;"><a href="across.html">if_any</a></td>
<td>Apply a function (or functions) across multiple columns</td></tr>
<tr><td style="width: 25%;"><a href="if_else.html">if_else</a></td>
<td>Vectorised if-else</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">inner_join</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">inner_join.data.frame</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">intersect</a></td>
<td>Set operations</td></tr>
<tr><td style="width: 25%;"><a href="tbl.html">is.tbl</a></td>
<td>Create a table from a data source</td></tr>
</table>

<h2><a id="J">-- J --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="mutate-joins.html">join</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">join.data.frame</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="join_by.html">join_by</a></td>
<td>Join specifications</td></tr>
</table>

<h2><a id="L">-- L --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="lead-lag.html">lag</a></td>
<td>Compute lagged or leading values</td></tr>
<tr><td style="width: 25%;"><a href="nth.html">last</a></td>
<td>Extract the first, last, or nth value from a vector</td></tr>
<tr><td style="width: 25%;"><a href="lead-lag.html">lead</a></td>
<td>Compute lagged or leading values</td></tr>
<tr><td style="width: 25%;"><a href="lead-lag.html">lead-lag</a></td>
<td>Compute lagged or leading values</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">left_join</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">left_join.data.frame</a></td>
<td>Mutating joins</td></tr>
</table>

<h2><a id="M">-- M --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="row_number.html">min_rank</a></td>
<td>Integer ranking functions</td></tr>
<tr><td style="width: 25%;"><a href="mutate.html">mutate</a></td>
<td>Create, modify, and delete columns</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">mutate-joins</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate.html">mutate.data.frame</a></td>
<td>Create, modify, and delete columns</td></tr>
</table>

<h2><a id="N">-- N --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="context.html">n</a></td>
<td>Information about the "current" group or variable</td></tr>
<tr><td style="width: 25%;"><a href="na_if.html">na_if</a></td>
<td>Convert values to 'NA'</td></tr>
<tr><td style="width: 25%;"><a href="near.html">near</a></td>
<td>Compare two numeric vectors</td></tr>
<tr><td style="width: 25%;"><a href="nest_join.html">nest_join</a></td>
<td>Nest join</td></tr>
<tr><td style="width: 25%;"><a href="nest_join.html">nest_join.data.frame</a></td>
<td>Nest join</td></tr>
<tr><td style="width: 25%;"><a href="nth.html">nth</a></td>
<td>Extract the first, last, or nth value from a vector</td></tr>
<tr><td style="width: 25%;"><a href="ntile.html">ntile</a></td>
<td>Bucket a numeric vector into 'n' groups</td></tr>
<tr><td style="width: 25%;"><a href="n_distinct.html">n_distinct</a></td>
<td>Count unique combinations</td></tr>
</table>

<h2><a id="O">-- O --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="order_by.html">order_by</a></td>
<td>A helper function for ordering window function output</td></tr>
<tr><td style="width: 25%;"><a href="join_by.html">overlaps</a></td>
<td>Join specifications</td></tr>
</table>

<h2><a id="P">-- P --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="percent_rank.html">percent_rank</a></td>
<td>Proportional ranking functions</td></tr>
<tr><td style="width: 25%;"><a href="pick.html">pick</a></td>
<td>Select a subset of columns</td></tr>
<tr><td style="width: 25%;"><a href="pull.html">pull</a></td>
<td>Extract a single column</td></tr>
</table>

<h2><a id="R">-- R --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="recode.html">recode</a></td>
<td>Recode values</td></tr>
<tr><td style="width: 25%;"><a href="recode.html">recode_factor</a></td>
<td>Recode values</td></tr>
<tr><td style="width: 25%;"><a href="reframe.html">reframe</a></td>
<td>Transform each group to an arbitrary number of rows</td></tr>
<tr><td style="width: 25%;"><a href="relocate.html">relocate</a></td>
<td>Change column order</td></tr>
<tr><td style="width: 25%;"><a href="rename.html">rename</a></td>
<td>Rename columns</td></tr>
<tr><td style="width: 25%;"><a href="rename.html">rename_with</a></td>
<td>Rename columns</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">right_join</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="mutate-joins.html">right_join.data.frame</a></td>
<td>Mutating joins</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_append</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_delete</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_insert</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_patch</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_update</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rows.html">rows_upsert</a></td>
<td>Manipulate individual rows</td></tr>
<tr><td style="width: 25%;"><a href="rowwise.html">rowwise</a></td>
<td>Group input by rows</td></tr>
<tr><td style="width: 25%;"><a href="row_number.html">row_number</a></td>
<td>Integer ranking functions</td></tr>
</table>

<h2><a id="S">-- S --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="scoped.html">scoped</a></td>
<td>Operate on a selection of variables</td></tr>
<tr><td style="width: 25%;"><a href="select.html">select</a></td>
<td>Keep or drop columns using their names and types</td></tr>
<tr><td style="width: 25%;"><a href="filter-joins.html">semi_join</a></td>
<td>Filtering joins</td></tr>
<tr><td style="width: 25%;"><a href="filter-joins.html">semi_join.data.frame</a></td>
<td>Filtering joins</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">setdiff</a></td>
<td>Set operations</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">setequal</a></td>
<td>Set operations</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">setops</a></td>
<td>Set operations</td></tr>
<tr><td style="width: 25%;"><a href="explain.html">show_query</a></td>
<td>Explain details of a tbl</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice_head</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice_max</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice_min</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice_sample</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="slice.html">slice_tail</a></td>
<td>Subset rows using their positions</td></tr>
<tr><td style="width: 25%;"><a href="sql.html">sql</a></td>
<td>SQL escaping.</td></tr>
<tr><td style="width: 25%;"><a href="starwars.html">starwars</a></td>
<td>Starwars characters</td></tr>
<tr><td style="width: 25%;"><a href="storms.html">storms</a></td>
<td>Storm tracks data</td></tr>
<tr><td style="width: 25%;"><a href="summarise.html">summarise</a></td>
<td>Summarise each group down to one row</td></tr>
<tr><td style="width: 25%;"><a href="summarise.html">summarize</a></td>
<td>Summarise each group down to one row</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">symdiff</a></td>
<td>Set operations</td></tr>
</table>

<h2><a id="T">-- T --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="count.html">tally</a></td>
<td>Count the observations in each group</td></tr>
<tr><td style="width: 25%;"><a href="tbl.html">tbl</a></td>
<td>Create a table from a data source</td></tr>
</table>

<h2><a id="U">-- U --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="group_by.html">ungroup</a></td>
<td>Group by one or more variables</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">union</a></td>
<td>Set operations</td></tr>
<tr><td style="width: 25%;"><a href="setops.html">union_all</a></td>
<td>Set operations</td></tr>
</table>

<h2><a id="V">-- V --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="vars.html">vars</a></td>
<td>Select variables</td></tr>
</table>

<h2><a id="W">-- W --</a></h2>

<table style="width: 100%;">
<tr><td style="width: 25%;"><a href="join_by.html">within</a></td>
<td>Join specifications</td></tr>
</table>
</div></body></html>
